<?xml version="1.0" encoding="utf-8" ?>
<MSSQL>
  <MSSQLServer>
    <!-- Server name -->
    <DatabaseServer>PRODSITE</DatabaseServer>
    <!-- Server instance, blank for none -->
    <Instance></Instance>
    <!-- Database name -->
    <Database>TimeTracker</Database>
    <!-- Set to True to use a trusted connection -->
    <UseIntegratedSecurity>False</UseIntegratedSecurity>
    <!-- If not using a trusted connection, set the user name and password -->
    <UserID>sa</UserID>
    <Password>spectrum</Password>
    <!-- The SQL query to run against the connection.
         The idea is to generate tables with three types of content:
         - System information, which includes information about MSSQL Server.
         - Database information, which includes information about the database.
         - Table information, which includes information about individual tables.
         The type of content included in tables is identified to the collector by
         the contents of the Content column.
    -->
    <SQLQuery>
      SELECT 'SystemInformation' AS 'Content',
      SERVERPROPERTY('servername') AS 'ServerName',
      SERVERPROPERTY('edition') AS 'Edition',
      SERVERPROPERTY('instancename') AS 'InstanceName',
      SERVERPROPERTY('productversion') AS 'ProductVersion',
      SERVERPROPERTY('processid') AS 'ProcessID';
      SELECT 'DatabaseInformation' AS 'Content', Size, Name, Filename
      FROM sysfiles
      CREATE TABLE #tbl (
      [content] [nvarchar] (50),
      [Name] [nvarchar] (50),
      [Rows] [int],
      [Reserved] [nvarchar] (50),
      [Data] [nvarchar] (50),
      [Index_size] [nvarchar] (50),
      [Unused] [nvarchar] (50)
      ) ON [PRIMARY]
      INSERT INTO #tbl(name, rows, reserved, data, index_size, unused) exec sp_spaceused users, 'False'
      INSERT INTO #tbl(name, rows, reserved, data, index_size, unused) exec sp_spaceused roles, 'False'
      INSERT INTO #tbl(name, rows, reserved, data, index_size, unused) exec sp_spaceused packages, 'False'
      UPDATE #tbl SET content='TableInfo'
      SELECT * FROM #tbl
      DROP TABLE #tbl
    </SQLQuery>
  </MSSQLServer>
</MSSQL>